package com.java.servlet.web.menu.dao.sql;

public class SqlMenu {
	public static final String LISTA_MENU;

	static {
		StringBuilder qryBuilder = new StringBuilder();
		qryBuilder.append("SELECT CAT_ROLES.ID_ROL,CAT_ROLES.DESC_ROL,SIS_MENU.ID_MENU,SIS_MENU.DESC_MENU,SIS_MENU.PARENT,SIS_MENU.ID_PARENT,SIS_MENU.LINK FROM SIS_CAT_ROLES CAT_ROLES, SIS_MENUS_ROL MENU_ROL, SIS_MENUS SIS_MENU " +
						  " WHERE CAT_ROLES.ID_ROL = ? " +
						  " AND CAT_ROLES.ID_ROL  = MENU_ROL.ID_ROL "+ 
						  " AND MENU_ROL.ID_MENU  = SIS_MENU.ID_MENU "+
						  " ORDER BY ID_MENU ASC");
		LISTA_MENU = qryBuilder.toString();
	}
}
